﻿
using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Text;
using Common.DBUtility;
using lib.Model;
namespace lib.DAL
{
    public partial class MenuInfo_Dal
    {
        /// <summary>
        /// 获取当前用户的菜单权限
        /// </summary>
        /// <param name="roleId"></param>
        /// <returns></returns>
        public IList<MenuInfo_Model> GetCurrentUserRoleMenu(int roleId)
        {
            string sql = "select * from MenuInfo where fdMenuID in(select fdRoleMenuID from RoleMenuManage where fdRoleManageID=@fdRoleManageID) and fdMenuIsEnable=1";
            return GetModelList(sql, new SqlParameter("@fdRoleManageID", roleId));
        }
    }
}
  
